import xlrd

def get_value(file_name,sheet_name):
    book=xlrd.open_workbook_xls(file_name)
    sheet=book.sheet_by_name(sheet_name)
    n=sheet.nrows
    list1=[]
    for i in range(n):
        if i >0:
            value=sheet.row_values(i,1)
            list1.append(value)
    return list1
if __name__ == '__main__':
    print(get_value(r"D:\python_tl\ui_auto2\data\data1.xls","Sheet1"))